
-- ----------------------------
-- Records of onl_graphreport_head
-- ----------------------------
INSERT INTO [dbo].[onl_graphreport_head] ([id], [name], [code], [cgr_sql], [xaxis_field], [yaxis_field], [yaxis_text], [content], [extend_js], [graph_type], [is_combination], [display_template], [data_type], [create_time], [create_by], [update_time], [update_by]) VALUES (N'0dbeb0dfc3ec18f0ce8d1d0caeeb6095', N'统计近十日的登陆次数', N'login_count_charts', N'SELECT
	count(*) num,
  CONVERT(varchar(100), create_time, 23) AS [day]
FROM
	sys_log
WHERE
	log_type = 1
 AND create_time > convert(char(10),dateadd(dd,-10,getdate()),120) 
GROUP BY
	CONVERT(varchar(100), create_time, 23)', N'day', N'num', N'登陆次数', N'统计登陆', N'', N'line,pie,bar,table', N'combination', N'tab', N'sql', N'2019-04-11 14:36:30.0000000', N'admin', N'2019-04-11 14:36:55.0000000', N'admin')
GO
GO
INSERT INTO [dbo].[onl_graphreport_head] ([id], [name], [code], [cgr_sql], [xaxis_field], [yaxis_field], [yaxis_text], [content], [extend_js], [graph_type], [is_combination], [display_template], [data_type], [create_time], [create_by], [update_time], [update_by]) VALUES (N'1c034f6063cee129e6aa32016ac42ce8', N'项目性质收入统计SQL', N'project_statistics_sql', N'SELECT
	id,
	nature,
	insurance_fee,
	risk_consulting_fee,
	evaluation_fee,
	insurance_evaluation_fee,
	bidding_consulting_fee,
	interol_consulting_fee,
	(
		insurance_fee + 
		risk_consulting_fee + 
		risk_consulting_fee + 
		evaluation_fee + 
		insurance_evaluation_fee + 
		bidding_consulting_fee + 
		interol_consulting_fee
	) AS ''total''
FROM
	jeecg_project_nature_income', N'nature', N'total', N'总计', N'', N'', N'pie,bar,table', N'combination', N'tab', N'sql', N'2019-04-28 15:01:30.0000000', N'admin', N'2019-04-28 15:01:44.0000000', N'admin')
GO
GO
INSERT INTO [dbo].[onl_graphreport_head] ([id], [name], [code], [cgr_sql], [xaxis_field], [yaxis_field], [yaxis_text], [content], [extend_js], [graph_type], [is_combination], [display_template], [data_type], [create_time], [create_by], [update_time], [update_by]) VALUES (N'27accd782f98c41eae5fad1b0514238d', N'月度增长分析同比', N'monthly_growth_analysis', N'SELECT
	id,
	[month],
	main_income AS main_income_2018,
	other_income AS other_income_2018,
	(
		main_income + other_income
	) AS [2018年月总收入],
(
		SELECT
			main_income
		FROM
			jeecg_monthly_growth_analysis AS year2
		WHERE
			year1.[month]= year2.[month]
		AND year2.[year] = ''2019''
	) AS [main_income_2019],
(
		SELECT
			other_income
		FROM
			jeecg_monthly_growth_analysis AS year2
		WHERE
			year1.[month] = year2.[month]
		AND year2.[year] = ''2019''
	) AS [other_income_2019],
(
		SELECT
			(
				main_income + other_income
			)
		FROM
			jeecg_monthly_growth_analysis AS year2
		WHERE
			year1.[month] = year2.[month]
		AND year2.[year] = ''2019''
	) AS [2019年月总收入]
FROM
	jeecg_monthly_growth_analysis year1
WHERE
	year1.[year] = ''2018''', N'month', N'2018年月总收入,2019年月总收入', N'-', N'', N'', N'table,line,bar', N'combination', N'double', N'sql', N'2019-04-28 16:47:37.0000000', N'admin', N'2019-04-28 16:48:07.0000000', N'admin')
GO
GO
INSERT INTO [dbo].[onl_graphreport_head] ([id], [name], [code], [cgr_sql], [xaxis_field], [yaxis_field], [yaxis_text], [content], [extend_js], [graph_type], [is_combination], [display_template], [data_type], [create_time], [create_by], [update_time], [update_by]) VALUES (N'3a84e175265289e1abff36be3c9f0e4a', N'统计一周内步数', N'week_count_step', N'[
    {"day": "星期一", "step": 1234, "assess": "良"},
    {"day": "星期二", "step": 1884, "assess": "优"},
    {"day": "星期三", "step": 1671, "assess": "良+"},
    {"day": "星期四", "step": 2197, "assess": "优+"},
    {"day": "星期五", "step": 1342, "assess": "中"},
    {"day": "星期六", "step": 545, "assess": "差"},
    {"day": "星期日", "step": 244, "assess": "极差"}
]', N'day', N'step', N'步数', N'', N'', N'bar,line,pie,table', N'combination', N'tab', N'json', N'2019-04-24 15:32:24.0000000', N'admin', N'2019-04-24 16:12:44.0000000', N'admin')
GO
GO
INSERT INTO [dbo].[onl_graphreport_head] ([id], [name], [code], [cgr_sql], [xaxis_field], [yaxis_field], [yaxis_text], [content], [extend_js], [graph_type], [is_combination], [display_template], [data_type], [create_time], [create_by], [update_time], [update_by]) VALUES (N'd2bbe1cec4260fe2d4d9e8536fa92ab8', N'项目性质收入统计JSON', N'project_statistics', N'[
    {
        "column1": "市场化-电商业务",
        "column2": 4865.41,
        "column3": 0,
        "column4": 0,
        "column5": 0,
        "column6": 0,
        "column7": 0,
        "column8": 4865.41
    },
    {
        "column1": "统筹型",
        "column2": 35767081.88,
        "column3": 0,
        "column4": 0,
        "column5": 0,
        "column6": 0,
        "column7": 0,
        "column8": 35767081.88
    },
    {
        "column1": "市场化-非股东",
        "column2": 1487045.35,
        "column3": 0,
        "column4": 0,
        "column5": 0,
        "column6": 0,
        "column7": 0,
        "column8": 1487045.35
    },
    {
        "column1": "市场化-参控股",
        "column2": 382690.56,
        "column3": 0,
        "column4": 0,
        "column5": 0,
        "column6": 0,
        "column7": 0,
        "column8": 382690.56
    },
    {
        "column1": "市场化-员工福利",
        "column2": 256684.91,
        "column3": 0,
        "column4": 0,
        "column5": 0,
        "column6": 0,
        "column7": 0,
        "column8": 265684.91
    },
    {
        "column1": "市场化-再保险",
        "column2": 563451.03,
        "column3": 0,
        "column4": 0,
        "column5": 0,
        "column6": 0,
        "column7": 0,
        "column8": 563451.03
    },
    {
        "column1": "市场化-海外业务",
        "column2": 760576.25,
        "column3": 770458.75,
        "column4": 0,
        "column5": 0,
        "column6": 0,
        "column7": 0,
        "column8": 1531035.00
    },
    {
        "column1": "市场化-风险咨询",
        "column2": 0.00,
        "column3": 910183.93,
        "column4": 0,
        "column5": 0,
        "column6": 0,
        "column7": 226415.09,
        "column8": 1136599.02
    }
]', N'column1', N'column8', N'总计', N'', N'', N'pie,bar,line,table', N'combination', N'double', N'json', N'2019-04-23 16:57:14.0000000', N'admin', N'2019-04-23 16:57:51.0000000', N'admin')


-- ----------------------------
-- Records of onl_graphreport_item
-- ----------------------------
INSERT INTO [dbo].[onl_graphreport_item] ([id], [graphreport_head_id], [field_name], [field_txt], [is_show], [is_total], [search_flag], [search_mode], [dict_code], [field_href], [field_type], [order_num], [replace_val], [create_by], [create_time], [update_by], [update_time]) VALUES (N'15549645263910', N'0dbeb0dfc3ec18f0ce8d1d0caeeb6095', N'day', N'日期', N'Y', N'N', N'Y', N'group', N'', null, N'Date', N'2', null, N'admin', N'2019-05-16 11:28:24.0000000', null, null)
GO
GO
INSERT INTO [dbo].[onl_graphreport_item] ([id], [graphreport_head_id], [field_name], [field_txt], [is_show], [is_total], [search_flag], [search_mode], [dict_code], [field_href], [field_type], [order_num], [replace_val], [create_by], [create_time], [update_by], [update_time]) VALUES (N'15549645793241', N'0dbeb0dfc3ec18f0ce8d1d0caeeb6095', N'num', N'登陆次数', N'Y', N'Y', N'Y', N'group', N'', null, N'Integer', N'3', null, N'admin', N'2019-05-16 11:28:24.0000000', null, null)
GO
GO
INSERT INTO [dbo].[onl_graphreport_item] ([id], [graphreport_head_id], [field_name], [field_txt], [is_show], [is_total], [search_flag], [search_mode], [dict_code], [field_href], [field_type], [order_num], [replace_val], [create_by], [create_time], [update_by], [update_time]) VALUES (N'15560092997490', N'd2bbe1cec4260fe2d4d9e8536fa92ab8', N'column1', N'项目性质', N'Y', N'N', N'N', null, N'', null, N'String', N'1', null, N'admin', N'2019-04-23 20:01:15.0000000', null, null)
GO
GO
INSERT INTO [dbo].[onl_graphreport_item] ([id], [graphreport_head_id], [field_name], [field_txt], [is_show], [is_total], [search_flag], [search_mode], [dict_code], [field_href], [field_type], [order_num], [replace_val], [create_by], [create_time], [update_by], [update_time]) VALUES (N'15560094786891', N'd2bbe1cec4260fe2d4d9e8536fa92ab8', N'column2', N'保险经纪佣金费', N'Y', N'Y', N'N', null, N'', null, N'Integer', N'2', null, N'admin', N'2019-04-23 20:01:15.0000000', null, null)
GO
GO
INSERT INTO [dbo].[onl_graphreport_item] ([id], [graphreport_head_id], [field_name], [field_txt], [is_show], [is_total], [search_flag], [search_mode], [dict_code], [field_href], [field_type], [order_num], [replace_val], [create_by], [create_time], [update_by], [update_time]) VALUES (N'15560094789692', N'd2bbe1cec4260fe2d4d9e8536fa92ab8', N'column3', N'风险咨询费', N'Y', N'Y', N'N', null, N'', null, N'Integer', N'3', null, N'admin', N'2019-04-23 20:01:15.0000000', null, null)
GO
GO
INSERT INTO [dbo].[onl_graphreport_item] ([id], [graphreport_head_id], [field_name], [field_txt], [is_show], [is_total], [search_flag], [search_mode], [dict_code], [field_href], [field_type], [order_num], [replace_val], [create_by], [create_time], [update_by], [update_time]) VALUES (N'15560094791553', N'd2bbe1cec4260fe2d4d9e8536fa92ab8', N'column4', N'承保公估评估费', N'Y', N'Y', N'N', null, N'', null, N'Integer', N'4', null, N'admin', N'2019-04-23 20:01:15.0000000', null, null)
GO
GO
INSERT INTO [dbo].[onl_graphreport_item] ([id], [graphreport_head_id], [field_name], [field_txt], [is_show], [is_total], [search_flag], [search_mode], [dict_code], [field_href], [field_type], [order_num], [replace_val], [create_by], [create_time], [update_by], [update_time]) VALUES (N'15560094793404', N'd2bbe1cec4260fe2d4d9e8536fa92ab8', N'column5', N'保险公估费', N'Y', N'Y', N'N', null, N'', null, N'Integer', N'5', null, N'admin', N'2019-04-23 20:01:15.0000000', null, null)
GO
GO
INSERT INTO [dbo].[onl_graphreport_item] ([id], [graphreport_head_id], [field_name], [field_txt], [is_show], [is_total], [search_flag], [search_mode], [dict_code], [field_href], [field_type], [order_num], [replace_val], [create_by], [create_time], [update_by], [update_time]) VALUES (N'15560095450035', N'd2bbe1cec4260fe2d4d9e8536fa92ab8', N'column6', N'投标咨询费', N'Y', N'Y', N'N', null, N'', null, N'Integer', N'6', null, N'admin', N'2019-04-23 20:01:15.0000000', null, null)
GO
GO
INSERT INTO [dbo].[onl_graphreport_item] ([id], [graphreport_head_id], [field_name], [field_txt], [is_show], [is_total], [search_flag], [search_mode], [dict_code], [field_href], [field_type], [order_num], [replace_val], [create_by], [create_time], [update_by], [update_time]) VALUES (N'15560095628356', N'd2bbe1cec4260fe2d4d9e8536fa92ab8', N'column7', N'内控咨询费', N'Y', N'Y', N'N', null, N'', null, N'Integer', N'7', null, N'admin', N'2019-04-23 20:01:15.0000000', null, null)
GO
GO
INSERT INTO [dbo].[onl_graphreport_item] ([id], [graphreport_head_id], [field_name], [field_txt], [is_show], [is_total], [search_flag], [search_mode], [dict_code], [field_href], [field_type], [order_num], [replace_val], [create_by], [create_time], [update_by], [update_time]) VALUES (N'15560129810847', N'd2bbe1cec4260fe2d4d9e8536fa92ab8', N'column8', N'总计', N'Y', N'Y', N'N', null, N'', null, N'Integer', N'8', null, N'admin', N'2019-04-23 20:01:15.0000000', null, null)
GO
GO
INSERT INTO [dbo].[onl_graphreport_item] ([id], [graphreport_head_id], [field_name], [field_txt], [is_show], [is_total], [search_flag], [search_mode], [dict_code], [field_href], [field_type], [order_num], [replace_val], [create_by], [create_time], [update_by], [update_time]) VALUES (N'15560934964380', N'3a84e175265289e1abff36be3c9f0e4a', N'day', N'星期', N'Y', N'N', N'N', null, N'', null, N'String', N'1', null, N'admin', N'2019-04-28 20:43:47.0000000', null, null)
GO
GO
INSERT INTO [dbo].[onl_graphreport_item] ([id], [graphreport_head_id], [field_name], [field_txt], [is_show], [is_total], [search_flag], [search_mode], [dict_code], [field_href], [field_type], [order_num], [replace_val], [create_by], [create_time], [update_by], [update_time]) VALUES (N'15560934966151', N'3a84e175265289e1abff36be3c9f0e4a', N'step', N'步数', N'Y', N'Y', N'N', null, N'', null, N'Integer', N'2', null, N'admin', N'2019-04-28 20:43:47.0000000', null, null)
GO
GO
INSERT INTO [dbo].[onl_graphreport_item] ([id], [graphreport_head_id], [field_name], [field_txt], [is_show], [is_total], [search_flag], [search_mode], [dict_code], [field_href], [field_type], [order_num], [replace_val], [create_by], [create_time], [update_by], [update_time]) VALUES (N'15560934968542', N'3a84e175265289e1abff36be3c9f0e4a', N'assess', N'评估', N'Y', N'N', N'N', null, N'', null, N'String', N'3', null, N'admin', N'2019-04-28 20:43:47.0000000', null, null)
GO
GO
INSERT INTO [dbo].[onl_graphreport_item] ([id], [graphreport_head_id], [field_name], [field_txt], [is_show], [is_total], [search_flag], [search_mode], [dict_code], [field_href], [field_type], [order_num], [replace_val], [create_by], [create_time], [update_by], [update_time]) VALUES (N'15564348662400', N'1c034f6063cee129e6aa32016ac42ce8', N'nature', N'项目性质', N'Y', N'N', N'N', null, N'', null, N'String', N'1', null, N'admin', N'2019-04-29 19:36:09.0000000', null, null)
GO
GO
INSERT INTO [dbo].[onl_graphreport_item] ([id], [graphreport_head_id], [field_name], [field_txt], [is_show], [is_total], [search_flag], [search_mode], [dict_code], [field_href], [field_type], [order_num], [replace_val], [create_by], [create_time], [update_by], [update_time]) VALUES (N'15564361547441', N'1c034f6063cee129e6aa32016ac42ce8', N'insurance_fee', N'保险经纪佣金费', N'Y', N'Y', N'N', null, N'', null, N'Integer', N'2', null, N'admin', N'2019-04-29 19:36:09.0000000', null, null)
GO
GO
INSERT INTO [dbo].[onl_graphreport_item] ([id], [graphreport_head_id], [field_name], [field_txt], [is_show], [is_total], [search_flag], [search_mode], [dict_code], [field_href], [field_type], [order_num], [replace_val], [create_by], [create_time], [update_by], [update_time]) VALUES (N'15564361549062', N'1c034f6063cee129e6aa32016ac42ce8', N'risk_consulting_fee', N'风险咨询费', N'Y', N'Y', N'N', null, N'', null, N'Integer', N'3', null, N'admin', N'2019-04-29 19:36:09.0000000', null, null)
GO
GO
INSERT INTO [dbo].[onl_graphreport_item] ([id], [graphreport_head_id], [field_name], [field_txt], [is_show], [is_total], [search_flag], [search_mode], [dict_code], [field_href], [field_type], [order_num], [replace_val], [create_by], [create_time], [update_by], [update_time]) VALUES (N'15564361550833', N'1c034f6063cee129e6aa32016ac42ce8', N'evaluation_fee', N'承保公估评估费', N'Y', N'Y', N'N', null, N'', null, N'Integer', N'4', null, N'admin', N'2019-04-29 19:36:09.0000000', null, null)
GO
GO
INSERT INTO [dbo].[onl_graphreport_item] ([id], [graphreport_head_id], [field_name], [field_txt], [is_show], [is_total], [search_flag], [search_mode], [dict_code], [field_href], [field_type], [order_num], [replace_val], [create_by], [create_time], [update_by], [update_time]) VALUES (N'15564361552344', N'1c034f6063cee129e6aa32016ac42ce8', N'insurance_evaluation_fee', N'保险公估费', N'Y', N'Y', N'N', null, N'', null, N'Integer', N'5', null, N'admin', N'2019-04-29 19:36:09.0000000', null, null)
GO
GO
INSERT INTO [dbo].[onl_graphreport_item] ([id], [graphreport_head_id], [field_name], [field_txt], [is_show], [is_total], [search_flag], [search_mode], [dict_code], [field_href], [field_type], [order_num], [replace_val], [create_by], [create_time], [update_by], [update_time]) VALUES (N'15564361553795', N'1c034f6063cee129e6aa32016ac42ce8', N'bidding_consulting_fee', N'投标咨询费', N'Y', N'Y', N'N', null, N'', null, N'Integer', N'6', null, N'admin', N'2019-04-29 19:36:09.0000000', null, null)
GO
GO
INSERT INTO [dbo].[onl_graphreport_item] ([id], [graphreport_head_id], [field_name], [field_txt], [is_show], [is_total], [search_flag], [search_mode], [dict_code], [field_href], [field_type], [order_num], [replace_val], [create_by], [create_time], [update_by], [update_time]) VALUES (N'15564362268486', N'1c034f6063cee129e6aa32016ac42ce8', N'interol_consulting_fee', N'内控咨询费', N'Y', N'Y', N'N', null, N'', null, N'Integer', N'7', null, N'admin', N'2019-04-29 19:36:09.0000000', null, null)
GO
GO
INSERT INTO [dbo].[onl_graphreport_item] ([id], [graphreport_head_id], [field_name], [field_txt], [is_show], [is_total], [search_flag], [search_mode], [dict_code], [field_href], [field_type], [order_num], [replace_val], [create_by], [create_time], [update_by], [update_time]) VALUES (N'15564411440430', N'27accd782f98c41eae5fad1b0514238d', N'month', N'月份', N'Y', N'N', N'N', null, N'', null, N'String', N'1', null, N'admin', N'2019-05-17 16:14:59.4730000', null, null)
GO
GO
INSERT INTO [dbo].[onl_graphreport_item] ([id], [graphreport_head_id], [field_name], [field_txt], [is_show], [is_total], [search_flag], [search_mode], [dict_code], [field_href], [field_type], [order_num], [replace_val], [create_by], [create_time], [update_by], [update_time]) VALUES (N'15564411960551', N'27accd782f98c41eae5fad1b0514238d', N'main_income_2018', N'佣金/主营收入(2018)', N'Y', N'N', N'N', null, N'', null, N'Integer', N'2', null, N'admin', N'2019-05-17 16:14:59.4890000', null, null)
GO
GO
INSERT INTO [dbo].[onl_graphreport_item] ([id], [graphreport_head_id], [field_name], [field_txt], [is_show], [is_total], [search_flag], [search_mode], [dict_code], [field_href], [field_type], [order_num], [replace_val], [create_by], [create_time], [update_by], [update_time]) VALUES (N'15564411987042', N'27accd782f98c41eae5fad1b0514238d', N'other_income_2018', N'其他收入(2018)', N'Y', N'N', N'N', null, N'', null, N'Integer', N'3', null, N'admin', N'2019-05-17 16:14:59.5180000', null, null)
GO
GO
INSERT INTO [dbo].[onl_graphreport_item] ([id], [graphreport_head_id], [field_name], [field_txt], [is_show], [is_total], [search_flag], [search_mode], [dict_code], [field_href], [field_type], [order_num], [replace_val], [create_by], [create_time], [update_by], [update_time]) VALUES (N'15564412356403', N'27accd782f98c41eae5fad1b0514238d', N'2018年月总收入', N'2018年本月总收入', N'N', N'N', N'N', null, N'', null, N'Integer', N'4', null, N'admin', N'2019-05-17 16:14:59.5610000', null, null)
GO
GO
INSERT INTO [dbo].[onl_graphreport_item] ([id], [graphreport_head_id], [field_name], [field_txt], [is_show], [is_total], [search_flag], [search_mode], [dict_code], [field_href], [field_type], [order_num], [replace_val], [create_by], [create_time], [update_by], [update_time]) VALUES (N'15564486143284', N'27accd782f98c41eae5fad1b0514238d', N'main_income_2019', N'佣金/主营收入(2019)', N'N', N'N', N'N', null, N'', null, N'Integer', N'5', null, N'admin', N'2019-05-17 16:14:59.5780000', null, null)
GO
GO
INSERT INTO [dbo].[onl_graphreport_item] ([id], [graphreport_head_id], [field_name], [field_txt], [is_show], [is_total], [search_flag], [search_mode], [dict_code], [field_href], [field_type], [order_num], [replace_val], [create_by], [create_time], [update_by], [update_time]) VALUES (N'15564486147175', N'27accd782f98c41eae5fad1b0514238d', N'other_income_2019', N'其他收入(2019)', N'N', N'N', N'N', null, N'', null, N'Integer', N'6', null, N'admin', N'2019-05-17 16:14:59.5870000', null, null)
GO
GO
INSERT INTO [dbo].[onl_graphreport_item] ([id], [graphreport_head_id], [field_name], [field_txt], [is_show], [is_total], [search_flag], [search_mode], [dict_code], [field_href], [field_type], [order_num], [replace_val], [create_by], [create_time], [update_by], [update_time]) VALUES (N'15564486150506', N'27accd782f98c41eae5fad1b0514238d', N'2019年月总收入', N'2019年本月总收入', N'N', N'N', N'N', null, N'', null, N'Integer', N'7', null, N'admin', N'2019-05-17 16:14:59.6020000', null, null)
GO
GO


-- ----------------------------
-- Records of onl_graphreport_templet
-- ----------------------------
INSERT INTO [dbo].[onl_graphreport_templet] ([id], [templet_code], [templet_name], [templet_style], [create_time], [create_by], [update_time], [update_by]) VALUES (N'02ff397e9714a22bf6efdfc7ba6d9041', N'test_many_source_tab', N'多数据源Tab风格', N'tab', N'2019-04-18 19:33:39.0000000', N'admin', N'2019-04-18 19:33:52.0000000', N'admin')
GO
GO
INSERT INTO [dbo].[onl_graphreport_templet] ([id], [templet_code], [templet_name], [templet_style], [create_time], [create_by], [update_time], [update_by]) VALUES (N'46a14bee5780f2c0cc7a785c94a0b6a7', N'test_many_source_double', N'多数据源双排风格', N'double', N'2019-04-17 18:20:58.0000000', N'admin', N'2019-04-17 18:21:14.0000000', N'admin')
GO
GO
INSERT INTO [dbo].[onl_graphreport_templet] ([id], [templet_code], [templet_name], [templet_style], [create_time], [create_by], [update_time], [update_by]) VALUES (N'bc154d35a1ec3eb4dd0f193dbecfbcb5', N'templet_combination', N'多数据源组合布局', N'combination', N'2019-05-11 16:18:44.0000000', N'admin', N'2019-05-11 16:19:52.0000000', N'admin')
GO
GO
INSERT INTO [dbo].[onl_graphreport_templet] ([id], [templet_code], [templet_name], [templet_style], [create_time], [create_by], [update_time], [update_by]) VALUES (N'dcf1e8aa1745937d511743f77ecfc40a', N'test_many_source_single', N'多数据源单排风格', N'single', N'2019-04-18 19:34:19.0000000', N'admin', N'2019-04-19 16:00:49.0000000', N'admin')
GO
GO

-- ----------------------------
-- Records of onl_graphreport_templet_item
-- ----------------------------
INSERT INTO [dbo].[onl_graphreport_templet_item] ([id], [graphreport_templet_id], [graphreport_code], [graphreport_type], [group_num], [group_style], [group_txt], [order_num], [is_show], [create_time], [create_by], [update_time], [update_by]) VALUES (N'12332331137671', N'46a14bee5780f2c0cc7a785c94a0b6a7', N'week_count_step', N'bar', N'0', N'card', N'统计', N'2', N'1', N'2019-04-26 19:12:37.0000000', N'admin', null, null)
GO
GO
INSERT INTO [dbo].[onl_graphreport_templet_item] ([id], [graphreport_templet_id], [graphreport_code], [graphreport_type], [group_num], [group_style], [group_txt], [order_num], [is_show], [create_time], [create_by], [update_time], [update_by]) VALUES (N'12332331142472', N'46a14bee5780f2c0cc7a785c94a0b6a7', N'project_statistics', N'normal', N'1', N'card', N'项目', N'1', N'1', N'2019-04-26 19:12:37.0000000', N'admin', null, null)
GO
GO
INSERT INTO [dbo].[onl_graphreport_templet_item] ([id], [graphreport_templet_id], [graphreport_code], [graphreport_type], [group_num], [group_style], [group_txt], [order_num], [is_show], [create_time], [create_by], [update_time], [update_by]) VALUES (N'12332332338280', N'46a14bee5780f2c0cc7a785c94a0b6a7', N'login_count_charts', N'line', N'0', N'card', N'统计', N'1', N'1', N'2019-04-26 19:12:37.0000000', N'admin', null, null)
GO
GO
INSERT INTO [dbo].[onl_graphreport_templet_item] ([id], [graphreport_templet_id], [graphreport_code], [graphreport_type], [group_num], [group_style], [group_txt], [order_num], [is_show], [create_time], [create_by], [update_time], [update_by]) VALUES (N'15552332338280', N'02ff397e9714a22bf6efdfc7ba6d9041', N'login_count_charts', N'line', N'0', N'card', N'统计', N'1', N'1', N'2019-04-26 18:49:59.0000000', N'admin', null, null)
GO
GO
INSERT INTO [dbo].[onl_graphreport_templet_item] ([id], [graphreport_templet_id], [graphreport_code], [graphreport_type], [group_num], [group_style], [group_txt], [order_num], [is_show], [create_time], [create_by], [update_time], [update_by]) VALUES (N'15555872338280', N'dcf1e8aa1745937d511743f77ecfc40a', N'login_count_charts', N'line', N'0', N'tabs', N'统计', N'1', N'1', N'2019-04-26 19:12:04.0000000', N'admin', null, null)
GO
GO
INSERT INTO [dbo].[onl_graphreport_templet_item] ([id], [graphreport_templet_id], [graphreport_code], [graphreport_type], [group_num], [group_style], [group_txt], [order_num], [is_show], [create_time], [create_by], [update_time], [update_by]) VALUES (N'15562331137671', N'02ff397e9714a22bf6efdfc7ba6d9041', N'week_count_step', N'bar', N'0', N'card', N'统计', N'2', N'1', N'2019-04-26 18:49:59.0000000', N'admin', null, null)
GO
GO
INSERT INTO [dbo].[onl_graphreport_templet_item] ([id], [graphreport_templet_id], [graphreport_code], [graphreport_type], [group_num], [group_style], [group_txt], [order_num], [is_show], [create_time], [create_by], [update_time], [update_by]) VALUES (N'15562331142472', N'02ff397e9714a22bf6efdfc7ba6d9041', N'project_statistics', N'normal', N'1', N'card', N'项目', N'1', N'1', N'2019-04-26 18:49:59.0000000', N'admin', null, null)
GO
GO
INSERT INTO [dbo].[onl_graphreport_templet_item] ([id], [graphreport_templet_id], [graphreport_code], [graphreport_type], [group_num], [group_style], [group_txt], [order_num], [is_show], [create_time], [create_by], [update_time], [update_by]) VALUES (N'15562671137671', N'dcf1e8aa1745937d511743f77ecfc40a', N'week_count_step', N'bar', N'0', N'tabs', N'统计', N'2', N'1', N'2019-04-26 19:12:04.0000000', N'admin', null, null)
GO
GO
INSERT INTO [dbo].[onl_graphreport_templet_item] ([id], [graphreport_templet_id], [graphreport_code], [graphreport_type], [group_num], [group_style], [group_txt], [order_num], [is_show], [create_time], [create_by], [update_time], [update_by]) VALUES (N'15562671142472', N'dcf1e8aa1745937d511743f77ecfc40a', N'project_statistics', N'normal', N'1', N'card', N'项目', N'1', N'1', N'2019-04-26 19:12:04.0000000', N'admin', null, null)
GO
GO
INSERT INTO [dbo].[onl_graphreport_templet_item] ([id], [graphreport_templet_id], [graphreport_code], [graphreport_type], [group_num], [group_style], [group_txt], [order_num], [is_show], [create_time], [create_by], [update_time], [update_by]) VALUES (N'15575624810180', N'bc154d35a1ec3eb4dd0f193dbecfbcb5', N'login_count_charts', N'line', N'0', N'card', N'1111', N'1', N'1', N'2019-05-11 18:49:14.0000000', N'admin', null, null)
GO
GO
INSERT INTO [dbo].[onl_graphreport_templet_item] ([id], [graphreport_templet_id], [graphreport_code], [graphreport_type], [group_num], [group_style], [group_txt], [order_num], [is_show], [create_time], [create_by], [update_time], [update_by]) VALUES (N'15575624830441', N'bc154d35a1ec3eb4dd0f193dbecfbcb5', N'project_statistics_sql', N'bar', N'0', N'card', N'1111', N'2', N'1', N'2019-05-11 18:49:14.0000000', N'admin', null, null)
GO
GO
INSERT INTO [dbo].[onl_graphreport_templet_item] ([id], [graphreport_templet_id], [graphreport_code], [graphreport_type], [group_num], [group_style], [group_txt], [order_num], [is_show], [create_time], [create_by], [update_time], [update_by]) VALUES (N'15575712802712', N'bc154d35a1ec3eb4dd0f193dbecfbcb5', N'monthly_growth_analysis', N'bar', N'1', N'card', N'1111', N'3', N'1', N'2019-05-11 18:49:14.0000000', N'admin', null, null)
GO
GO
INSERT INTO [dbo].[onl_graphreport_templet_item] ([id], [graphreport_templet_id], [graphreport_code], [graphreport_type], [group_num], [group_style], [group_txt], [order_num], [is_show], [create_time], [create_by], [update_time], [update_by]) VALUES (N'15575712972193', N'bc154d35a1ec3eb4dd0f193dbecfbcb5', N'week_count_step', N'line', N'1', N'card', N'1111', N'4', N'1', N'2019-05-11 18:49:14.0000000', N'admin', null, null)
GO
GO
